<cfparam default="none" name="url.type" />
<cfparam default="none" name="url.api" />

<cfoutput>

    
    <!---***************************************************************************************************--->
    <!---*************************************SELECTS*******************************************************--->  



    <!--- API that SELECTS Added staff.  Function: FuncQryGetRoster --->
    <cfif url.api eq "get_added_staff" >    
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="GET" >
            	#SerializeJSON(CreateObject("component", "SharePointModules.apt.cfc.queries").FuncQryGetRoster())#       
            </cfcase>    
        </cfswitch>
    </cfif>
    <!--- API that SELECTS Added staff.  Function: FuncQryGetRoster --->
    

    
    <!---*************************************SELECTS*******************************************************--->
    <!---***************************************************************************************************--->    
    
    
    
    
    
    
    
    
    
    <!---***************************************************************************************************--->
    <!---*************************************INSERTS*******************************************************--->
    
    
    <!--- API that INSERTS APT duty roster for a day.  Function: funcQryInsertRoster --->
    <cfif url.api eq "add_roster" >    
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
            	#CreateObject("component", "SharePointModules.apt.cfc.queries").funcQryInsertRoster(FORM)#       
            </cfcase>    
        </cfswitch>
    </cfif>
    <!--- API that INSERTS APT duty roster for a day.  Function: funcQryInsertRoster --->
    
    
    
    
    <!--- API that INSERTS Added staff to database.  Function: FuncQryAddToRoster --->
    <cfif url.api eq "add_added_staff" >    
        <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
            	#CreateObject("component", "SharePointModules.apt.cfc.queries").FuncQryAddToRoster(FORM)#       
            </cfcase>    
        </cfswitch>
    </cfif>
    <!--- API that INSERTS Added staff to database.  Function: FuncQryAddToRoster --->
    
    
    
    <!--- API that INSERTS Speical Instructions.  Function: FuncQryInsertSpecialInstructions --->
	<cfif url.api eq "add_special_instructions" >    
            <cfswitch expression="#CGI.REQUEST_METHOD#">
		<cfcase value="POST" >
            	    #CreateObject("component", "SharePointModules.apt.cfc.queries").FuncQryInsertSpecialInstructions(FORM)#       
		</cfcase>    
            </cfswitch>
	</cfif>
	<!--- API that INSERTS Speical Instructions.  Function: FuncQryInsertSpecialInstructions --->
    
	
	
<!---*************************************INSERTS*******************************************************--->
<!---***************************************************************************************************--->    









<!---***************************************************************************************************--->
<!---*************************************UPDATES*******************************************************--->  


<!---*************************************UPDATES*******************************************************--->
<!---***************************************************************************************************--->










<!---***************************************************************************************************--->
<!---*************************************DELETES*******************************************************--->


<!--- API that DELETES APT duty roster row by row id .  Function: FuncQryDeleteRosterByID --->
<cfif url.api eq "delete_roster_row" >    
    <cfswitch expression="#CGI.REQUEST_METHOD#">
            <cfcase value="POST" >
            	#CreateObject("component", "SharePointModules.apt.cfc.queries").FuncQryDeleteRosterByID(FORM.AptID)#       
            </cfcase>    
    </cfswitch>
</cfif>
<!--- API that DELETES APT duty roster row by row id .  Function: FuncQryDeleteRosterByID --->



<!--- API that DELETES a added staff by id  Function: FuncQryDeleteRoster --->
<cfif url.api eq "delete_added_staff" >    
    <cfswitch expression="#CGI.REQUEST_METHOD#">
        <cfcase value="POST" >
            #CreateObject("component", "SharePointModules.apt.cfc.queries").FuncQryDeleteRoster(FORM.AddedID)#       
        </cfcase>    
    </cfswitch>
</cfif>
<!--- API that DELETES a added staff by id  Function: FuncQryDeleteRoster --->



<!---*************************************DELETES*******************************************************--->
<!---***************************************************************************************************--->
</cfoutput>
